﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="userrole.aspx.cs" Inherits="orgman_users_userrole" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>用户角色管理</title>
    <link href="../../css/main.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
        <div id="content">
            <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
                DataKeyNames="userid" DataSourceID="SqlDataSource1" Width="100%">
                <Columns>
                    <asp:BoundField DataField="userid" HeaderText="userid" InsertVisible="False" 
                        ReadOnly="True" SortExpression="userid" Visible="False" />
                    <asp:BoundField DataField="username" HeaderText="用户名" 
                        SortExpression="username" />
                    <asp:BoundField DataField="realname" HeaderText="姓名" 
                        SortExpression="realname" />
                    <asp:BoundField DataField="sex" HeaderText="性别" SortExpression="sex" />
                    <asp:BoundField DataField="email" HeaderText="Email" SortExpression="email" />
                    <asp:BoundField DataField="mphone" HeaderText="移动电话" SortExpression="mphone" />
                    <asp:BoundField DataField="phone" HeaderText="phone" SortExpression="phone" 
                        Visible="False" />
                    <asp:BoundField DataField="address" HeaderText="address" 
                        SortExpression="address" Visible="False" />
                    <asp:BoundField DataField="postcode" HeaderText="postcode" 
                        SortExpression="postcode" Visible="False" />
                    <asp:BoundField DataField="organizationid" HeaderText="organizationid" 
                        SortExpression="organizationid" Visible="False" />
                    <asp:BoundField DataField="description" HeaderText="备注" 
                        SortExpression="description" />
                    <asp:CommandField ShowSelectButton="True">
                        <ItemStyle Width="30px" />
                    </asp:CommandField>
                </Columns>
            </asp:GridView>
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                ConnectionString="<%$ ConnectionStrings:appConnectionString %>" 
                SelectCommand="SELECT * FROM [users] WHERE ([organizationid] = @organizationid)">
                <SelectParameters>
                    <asp:SessionParameter Name="organizationid" SessionField="organizationid" 
                        Type="Int32" />
                </SelectParameters>
            </asp:SqlDataSource>
        </div>
    
    </div>
    </form>
</body>
</html>
